<?php
class retrieve_email extends retrieve_base{

	private $module_display_options 	= array();
	
	/**
	* function produces abstract structure of modules db structure
	*
    * used to generate the table structure required abstract function that passes an abstract
	* representation of the desired table structure to the proper database module which will
	* interpet the abstract and convert it into a valid SQL Create table structure.
	*
	* @return Array list of abstract table definitions for this module
	*/
	function create_table(){
		$tables = array();
		/**
		* Table structure for table 'email_addresses' a list of people that have subscribed
		* to a particular mailing list
		*/
		$fields = array(
			array("email_identifier"	,"unsigned integer"	,"NOT NULL"	,"auto_increment"	),
			array("email_client"		,"unsigned integer"	,"NOT NULL"	,"default '0'"		),
			array("email_address"		,"varchar(255)"		,"NOT NULL"	,"default ''"		),
			array("email_rtf"			,"small integer"	,"NOT NULL"	,"default '0'"		),
			array("email_codex"			,"varchar(6)"		,"NOT NULL"	,"default ''"		),
			array("email_date"			,"datetime"			,"NOT NULL"	,"default ''"		),
			array("email_verified"		,"small integer"	,"NOT NULL"	,"default '0'"		),
			array("email_contact"		,"unsigned integer"	,"NOT NULL"	,"default '0'"		)
		);
		$primary = "email_identifier";
		$tables[count($tables)] = array("email_addresses",$fields,$primary);

		return $tables;
	}

}
?>